*Salvaging Community Replication Code*

use "/Users/mxt725/Desktop/Research/Base Closure Project/BRAC Database
> /Salvaging CommunityreplicationData.dta"


*Author's note: This is an updated dataset that is abbreviated to include only the 
*variables in the models in Salvaging Community. The dataset also includes more bases than for the book. 

*Please write to miketouchton@miami.edu for additional variables, such as specific landuses on individual bases* 


*This replicates Table 3 in Chapter 2* 

reg percapjobscreated scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*

reg percapjobsreplacedratio scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*




*This replicates Table 4 in Chapter 2* 

reg logPerCap2017Revenue scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*




reg RevenueReplaced scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*


reg BondRatingRanking2017 scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*


*This replicates Table 5 in Chapter 2* 

logit Cleanupcomplete scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*


logistic Cleanupcomplete scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*


reg Percentlandtransferred scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*


*This replicates Table 6 in Chapter 2* 

ologit conversionscale scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*this is ready*


*This replicates Table 7 in Chapter 2* 


logit lowincomehousing scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust
logistic lowincomehousing scalefunding numberofpartners logLRAfunding airbaseorshipyard logEnviroCostsPerCap loglocalGDPpercap latebracround MSA basesize, robust

*ready*



*This replicates Table A.1 in the appendix*


logit leveragedprojects federalfunding statefunding localfunding numberofpartners environmentalhazard loglocalGDPpercap latebracround MSA basesize west midwest northeast
logistic leveragedprojects federalfunding statefunding localfunding numberofpartners environmentalhazard loglocalGDPpercap latebracround MSA basesize west midwest northeast

*ready*

logit replacementcommunity federalfunding statefunding localfunding numberofpartners environmentalhazard loglocalGDPpercap latebracround MSA basesize west midwest northeast
logistic replacementcommunity federalfunding statefunding localfunding numberofpartners environmentalhazard loglocalGDPpercap latebracround MSA basesize west midwest northeast

*ready*

*This replicates Table A.2 in the appendix*

logit leveragedprojects federalfunding statefunding localfunding numberofpartners environmentalhazard loglocalGDPpercap latebracround MSA basesize 
logistic leveragedprojects federalfunding statefunding localfunding numberofpartners environmentalhazard loglocalGDPpercap latebracround MSA basesize 

*ready*

logit replacementcommunity federalfunding statefunding localfunding numberofpartners environmentalhazard loglocalGDPpercap latebracround MSA basesize 
logistic replacementcommunity federalfunding statefunding localfunding numberofpartners environmentalhazard loglocalGDPpercap latebracround MSA basesize

*ready*


*This replicates Table A.3 in the appendix*

logit leveragedprojects nonprofitfunding privatefunding publicfunding  environmentalhazard loglocalGDPpercap latebracround MSA basesize west midwest northeast
logistic leveragedprojects nonprofitfunding privatefunding publicfunding environmentalhazard loglocalGDPpercap latebracround MSA basesize west midwest northeast

logit replacementcommunity nonprofitfunding privatefunding publicfunding environmentalhazard loglocalGDPpercap latebracround MSA basesize west midwest northeast
logistic replacementcommunity nonprofitfunding privatefunding publicfunding environmentalhazard loglocalGDPpercap latebracround MSA basesize west midwest northeast

